﻿/*ESRPConnectionString*/
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
/*Modificari pana la data de 01.01.2011*/
/**/


IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Consultatii' AND COLUMN_NAME = 'DopplerVenos')
BEGIN
ALTER TABLE dbo.Consultatii ADD
	DopplerVenos varchar(500) NULL  DEFAULT ('')
END
GO


IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Consultatii' AND COLUMN_NAME = 'DopplerArterial')
BEGIN
ALTER TABLE dbo.Consultatii ADD
	DopplerArterial varchar(500) NULL  DEFAULT ('')
END
GO


IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Consultatii' AND COLUMN_NAME = 'DopplerCarotidian')
BEGIN
ALTER TABLE dbo.Consultatii ADD
	DopplerCarotidian varchar(500) NULL  DEFAULT ('')
END
GO


IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Consultatii' AND COLUMN_NAME = 'HolterTA')
BEGIN
ALTER TABLE dbo.Consultatii ADD
	HolterTA varchar(500) NULL  DEFAULT ('')
END
GO


IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Consultatii' AND COLUMN_NAME = 'EKG')
BEGIN
ALTER TABLE dbo.Consultatii ADD
	EKG varchar(500) NULL  DEFAULT ('')
END
GO


IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Consultatii' AND COLUMN_NAME = 'HlterECG')
BEGIN
ALTER TABLE dbo.Consultatii ADD
	HolterECG varchar(500) NULL  DEFAULT ('')
END
GO

